﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;



namespace DataAccessTier
{
    class Invoices
    {
        private Excel.Application Application;
        
        public Invoices()
        {

        }

        public void getData()
        {
            //create a workbook and add it to the application
            Excel.Workbook newWorkbook = this.Application.Workbooks.Add(Type.Missing);


            this.Application.Workbooks.Open(@"C:\Test\YourWorkbook.xls",
                Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);


        }
    }
}
